// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_APP_ITEM
// * CreateDate    : 2014-06-05 18:30:35
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:35
// * LastChanger   : 2014-06-05 18:30:35
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SalesAppItemTable : TableInfo
    {
		public const string C_TableName = "SALES_APP_ITEM";
		
		public const string C_ID = "ID";
		public const string C_APP_ID = "APP_ID";
		public const string C_APP_NO = "APP_NO";
		public const string C_CONTACT_USER = "CONTACT_USER";
		public const string C_CONTACT_ID = "CONTACT_ID";
		public const string C_REQ_DELIVERY_DATE = "REQ_DELIVERY_DATE";
		public const string C_PRODUCT_ID = "PRODUCT_ID";
		public const string C_PRODUCT_NAME = "PRODUCT_NAME";
		public const string C_PRODUCT_CODE = "PRODUCT_CODE";
		public const string C_PRODUCT_SPEC = "PRODUCT_SPEC";
		public const string C_MATERIAL = "MATERIAL";
		public const string C_CUSTOMER_MODEL = "CUSTOMER_MODEL";
        public const string C_ITEM_TYPE = "ITEM_TYPE";
		public const string C_LENGTH = "LENGTH";
		public const string C_UNIT = "UNIT";
		public const string C_QTY = "QTY";
		public const string C_IS_TAX = "IS_TAX";
		public const string C_PRICE = "PRICE";
		public const string C_SUB_TOTAL = "SUB_TOTAL";
		public const string C_PRICE_TYPE = "PRICE_TYPE";
		public const string C_PRODUCT_TYPE = "PRODUCT_TYPE";
		public const string C_PACKAGE_TYPE = "PACKAGE_TYPE";
		public const string C_REMARK = "REMARK";
		public const string C_STATUS = "STATUS";
		
		public SalesAppItemTable()
        {
            _tableName = "SALES_APP_ITEM";
        }
		
		protected static SalesAppItemTable _current;
        public static SalesAppItemTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SalesAppItemTable();

            _current.Add(C_ID, new ColumnInfo(C_ID,"Id", true, typeof(string)));
            _current.Add(C_APP_ID, new ColumnInfo(C_APP_ID,"AppId", false, typeof(string)));
            _current.Add(C_APP_NO, new ColumnInfo(C_APP_NO,"AppNo", false, typeof(string)));
            _current.Add(C_CONTACT_USER, new ColumnInfo(C_CONTACT_USER,"ContactUser", false, typeof(string)));
            _current.Add(C_CONTACT_ID, new ColumnInfo(C_CONTACT_ID,"ContactId", false, typeof(string)));
            _current.Add(C_REQ_DELIVERY_DATE, new ColumnInfo(C_REQ_DELIVERY_DATE,"ReqDeliveryDate", false, typeof(DateTime)));
            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID,"ProductId", false, typeof(string)));
            _current.Add(C_PRODUCT_NAME, new ColumnInfo(C_PRODUCT_NAME,"ProductName", false, typeof(string)));
            _current.Add(C_PRODUCT_CODE, new ColumnInfo(C_PRODUCT_CODE,"ProductCode", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC, new ColumnInfo(C_PRODUCT_SPEC,"ProductSpec", false, typeof(string)));
            _current.Add(C_MATERIAL, new ColumnInfo(C_MATERIAL,"Material", false, typeof(string)));
            _current.Add(C_CUSTOMER_MODEL, new ColumnInfo(C_CUSTOMER_MODEL,"CustomerModel", false, typeof(string)));
            _current.Add(C_ITEM_TYPE, new ColumnInfo(C_ITEM_TYPE, "ItemType", false, typeof(string)));
            _current.Add(C_LENGTH, new ColumnInfo(C_LENGTH,"Length", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT,"Unit", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY,"Qty", false, typeof(decimal)));
            _current.Add(C_IS_TAX, new ColumnInfo(C_IS_TAX,"IsTax", false, typeof(int)));
            _current.Add(C_PRICE, new ColumnInfo(C_PRICE,"Price", false, typeof(decimal)));
            _current.Add(C_SUB_TOTAL, new ColumnInfo(C_SUB_TOTAL,"SubTotal", false, typeof(decimal)));
            _current.Add(C_PRICE_TYPE, new ColumnInfo(C_PRICE_TYPE,"PriceType", false, typeof(string)));
            _current.Add(C_PRODUCT_TYPE, new ColumnInfo(C_PRODUCT_TYPE,"ProductType", false, typeof(string)));
            _current.Add(C_PACKAGE_TYPE, new ColumnInfo(C_PACKAGE_TYPE,"PackageType", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
			
		}
		
		public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }
		
		public ColumnInfo APP_ID
        {
            get { return this[C_APP_ID]; }
        }
		
		public ColumnInfo APP_NO
        {
            get { return this[C_APP_NO]; }
        }
		
		public ColumnInfo CONTACT_USER
        {
            get { return this[C_CONTACT_USER]; }
        }
		
		public ColumnInfo CONTACT_ID
        {
            get { return this[C_CONTACT_ID]; }
        }
		
		public ColumnInfo REQ_DELIVERY_DATE
        {
            get { return this[C_REQ_DELIVERY_DATE]; }
        }
		
		public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }
		
		public ColumnInfo PRODUCT_NAME
        {
            get { return this[C_PRODUCT_NAME]; }
        }
		
		public ColumnInfo PRODUCT_CODE
        {
            get { return this[C_PRODUCT_CODE]; }
        }
		
		public ColumnInfo PRODUCT_SPEC
        {
            get { return this[C_PRODUCT_SPEC]; }
        }
		
		public ColumnInfo MATERIAL
        {
            get { return this[C_MATERIAL]; }
        }
		
		public ColumnInfo CUSTOMER_MODEL
        {
            get { return this[C_CUSTOMER_MODEL]; }
        }

        public ColumnInfo ITEM_TYPE
        {
            get { return this[C_ITEM_TYPE]; }
        }
		
		public ColumnInfo LENGTH
        {
            get { return this[C_LENGTH]; }
        }
		
		public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }
		
		public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }
		
		public ColumnInfo IS_TAX
        {
            get { return this[C_IS_TAX]; }
        }
		
		public ColumnInfo PRICE
        {
            get { return this[C_PRICE]; }
        }
		
		public ColumnInfo SUB_TOTAL
        {
            get { return this[C_SUB_TOTAL]; }
        }
		
		public ColumnInfo PRICE_TYPE
        {
            get { return this[C_PRICE_TYPE]; }
        }
		
		public ColumnInfo PRODUCT_TYPE
        {
            get { return this[C_PRODUCT_TYPE]; }
        }
		
		public ColumnInfo PACKAGE_TYPE
        {
            get { return this[C_PACKAGE_TYPE]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		
		
	}
}

